© UL Renewables Asset Advisory, USA
This section is to quickly summarize the values:
The goal is to automatically calculate the following summary statistics for the main data set provided.
Data set was for test Wind Farm
| Site.Name | WTG.Count | Manufacturer | Rating (kW) |
|---|---|---|---|
| test | 73 | ge | 2500 |
| DataSet_Total.Num.WTgs | DataSet_Total.WTGs.Data | WTG.Count.diff | Duplicated.WTGs |
|---|---|---|---|
| 73 | 73 | No missing WTGs | No |
CSV_Row_Count = 21096
MissingData_count BlankData_count
TimeStamp10Min 0 0
WTG 0 0
RealPower 0 0
WindSpeed 0 0
Rating 0 0
Below is a list of WTGs and their individual power rating. If there are more than one type of
WTG power rating the different rating will be shown in different colors.
| WTG | Rating (k/w) |
|---|---|
| WTG-0001 | 2500 |
| WTG-0002 | 2500 |
| WTG-0003 | 2500 |
| WTG-0004 | 2500 |
| WTG-0005 | 2500 |
| WTG-0006 | 2500 |
| WTG-0007 | 2500 |
| WTG-0008 | 2500 |
| WTG-0009 | 2500 |
| WTG-0010 | 2500 |
| WTG-0011 | 2500 |
| WTG-0012 | 2500 |
| WTG-0013 | 2500 |
| WTG-0014 | 2500 |
| WTG-0015 | 2500 |
| WTG-0016 | 2500 |
| WTG-0017 | 2500 |
| WTG-0018 | 2500 |
| WTG-0019 | 2500 |
| WTG-0020 | 2500 |
| WTG-0021 | 2500 |
| WTG-0022 | 2500 |
| WTG-0023 | 2500 |
| WTG-0024 | 2500 |
| WTG-0025 | 2500 |
| WTG-0026 | 2500 |
| WTG-0027 | 2500 |
| WTG-0028 | 2500 |
| WTG-0029 | 2500 |
| WTG-0030 | 2500 |
| WTG-0031 | 2500 |
| WTG-0032 | 2500 |
| WTG-0033 | 2500 |
| WTG-0034 | 2500 |
| WTG-0035 | 2500 |
| WTG-0036 | 2500 |
| WTG-0037 | 2500 |
| WTG-0038 | 2500 |
| WTG-0039 | 2500 |
| WTG-0040 | 2500 |
| WTG-0041 | 2500 |
| WTG-0042 | 2500 |
| WTG-0043 | 2500 |
| WTG-0044 | 2500 |
| WTG-0045 | 2500 |
| WTG-0046 | 2500 |
| WTG-0047 | 2500 |
| WTG-0048 | 2500 |
| WTG-0049 | 2500 |
| WTG-0050 | 2500 |
| WTG-0051 | 2500 |
| WTG-0052 | 2500 |
| WTG-0053 | 2500 |
| WTG-0054 | 2500 |
| WTG-0055 | 2500 |
| WTG-0056 | 2500 |
| WTG-0057 | 2500 |
| WTG-0058 | 2500 |
| WTG-0059 | 2500 |
| WTG-0060 | 2500 |
| WTG-0061 | 2500 |
| WTG-0062 | 2500 |
| WTG-0063 | 2500 |
| WTG-0064 | 2500 |
| WTG-0065 | 2500 |
| WTG-0066 | 2500 |
| WTG-0067 | 2500 |
| WTG-0068 | 2500 |
| WTG-0069 | 2500 |
| WTG-0070 | 2500 |
| WTG-0071 | 2500 |
| WTG-0072 | 2500 |
| WTG-0073 | 2500 |
Summary values below are for RealPower and WindSpeed Values for the full data set with all WTGs combined:
| RealPower | WindSpeed | |
|---|---|---|
| X | Min. : -24.471 | Min. : 0.000 |
| X.1 | 1st Qu.: -4.211 | 1st Qu.: 4.711 |
| X.2 | Median : 223.686 | Median : 6.348 |
| X.3 | Mean : 738.525 | Mean : 6.403 |
| X.4 | 3rd Qu.:1402.300 | 3rd Qu.: 8.261 |
| X.5 | Max. :2831.540 | Max. :15.930 |
TimeStamp10Min WTG RealPower WindSpeed Rating
1 2024-12-23 WTG-0001 -4.199 5.582 2500
2 2024-12-23 WTG-0001 -3.827 5.725 2500
3 2024-12-23 WTG-0001 -3.865 5.856 2500
4 2024-12-23 WTG-0001 -3.278 6.027 2500
5 2024-12-23 WTG-0001 -3.388 6.055 2500
6 2024-12-23 WTG-0001 -3.200 5.947 2500
7 2024-12-23 WTG-0001 -3.404 5.967 2500
8 2024-12-23 WTG-0001 -2.940 5.773 2500
9 2024-12-23 WTG-0001 -2.964 5.896 2500
10 2024-12-23 WTG-0001 -3.004 5.755 2500
Test for Power Production
WTG’s that FAIL a test below will be highlighted RED if one or both of these conditions are not achieved:
Notification of possible issues
WTG’s will be highlighted Orange if these conditions are meet. This is still considered a PASS, but will be a Notification:
DateStart = 2024-12-23 00:00 / DateEnd = 2024-12-25 00:00
| WTG | Rating (k/w) | MaxPower (k/w) | 98% of Rated | TotalProduction (k/w) | ReachRated_hrs | 3Days_Production_hrs | LastDayProduction_hrs |
|---|---|---|---|---|---|---|---|
| WTG-0001 | 2500 | 743.12 | 29.72% | 6477.98 | 0 | 12.33 | 6 |
| WTG-0002 | 2500 | 1828.88 | 73.16% | 16106.46 | 0 | 21.83 | 10 |
| WTG-0003 | 2500 | 2830.73 | 113.23% | 49806.53 | 5.83 | 31.33 | 19.83 |
| WTG-0004 | 2500 | 2831.38 | 113.26% | 43364.08 | 4.17 | 30.83 | 19 |
| WTG-0005 | 2500 | 2830.42 | 113.22% | 56658.76 | 7.67 | 31.5 | 20 |
| WTG-0006 | 2500 | 2219.25 | 88.77% | 14062.91 | 0 | 9.17 | 3 |
| WTG-0007 | 2500 | -2.81 | 0% | -212.14 | 0 | 0 | 0 |
| WTG-0008 | 2500 | 1917.92 | 76.72% | 770.67 | 0 | 0.83 | 0 |
| WTG-0009 | 2500 | 2831.05 | 113.24% | 53958.80 | 7 | 31.5 | 19.67 |
| WTG-0010 | 2500 | 2830.69 | 113.23% | 54824.20 | 7.67 | 31.5 | 19.67 |
| WTG-0011 | 2500 | 1386.31 | 55.45% | 1397.51 | 0 | 2 | 0 |
| WTG-0012 | 2500 | 2830.35 | 113.21% | 33123.07 | 2.33 | 29.67 | 19.67 |
| WTG-0013 | 2500 | 2830.47 | 113.22% | 45525.31 | 4.17 | 29.67 | 19.5 |
| WTG-0014 | 2500 | 2529.95 | 101.2% | 23735.19 | 0.83 | 27.67 | 16.33 |
| WTG-0015 | 2500 | 2830.96 | 113.24% | 46643.99 | 6 | 30.83 | 19.5 |
| WTG-0016 | 2500 | -3.06 | 0% | -203.03 | 0 | 0 | 0 |
| WTG-0017 | 2500 | 2830.52 | 113.22% | 37739.30 | 4 | 31.17 | 19.33 |
| WTG-0018 | 2500 | 2029.78 | 81.19% | 1648.87 | 0 | 1.67 | 0 |
| WTG-0019 | 2500 | 1327.57 | 53.1% | 14584.82 | 0 | 22.83 | 11.17 |
| WTG-0020 | 2500 | 2830.77 | 113.23% | 51958.46 | 4.17 | 33.17 | 21.33 |
| WTG-0021 | 2500 | 2830.71 | 113.23% | 61238.87 | 6.17 | 32.83 | 21.5 |
| WTG-0022 | 2500 | 2830.61 | 113.22% | 56090.69 | 5.17 | 33.17 | 21.33 |
| WTG-0023 | 2500 | 2830.45 | 113.22% | 56324.20 | 8 | 30.33 | 20 |
| WTG-0024 | 2500 | 2830.51 | 113.22% | 49403.87 | 5 | 32 | 20.17 |
| WTG-0025 | 2500 | 2725.56 | 109.02% | 51159.09 | 4 | 31.67 | 20.83 |
| WTG-0026 | 2500 | 2086.68 | 83.47% | 7904.29 | 0 | 8.5 | 0 |
| WTG-0027 | 2500 | 2830.95 | 113.24% | 58200.97 | 8.33 | 31.83 | 20.5 |
| WTG-0028 | 2500 | 2831.47 | 113.26% | 52482.13 | 5.17 | 32.33 | 20.67 |
| WTG-0029 | 2500 | 67.27 | 2.69% | -239.92 | 0 | 0 | 0 |
| WTG-0030 | 2500 | 2235.46 | 89.42% | 47845.79 | 0 | 31.17 | 20.5 |
| WTG-0031 | 2500 | 2830.68 | 113.23% | 58181.36 | 6.17 | 32 | 20.33 |
| WTG-0032 | 2500 | 2830.32 | 113.21% | 52058.69 | 5.67 | 32 | 20.67 |
| WTG-0033 | 2500 | 2830.96 | 113.24% | 50302.13 | 5 | 31.83 | 20.67 |
| WTG-0034 | 2500 | 2830.82 | 113.23% | 53035.10 | 5 | 31.33 | 20.17 |
| WTG-0035 | 2500 | 533.07 | 21.32% | 452.46 | 0 | 1.17 | 0 |
| WTG-0036 | 2500 | 190.8 | 7.63% | -183.07 | 0 | 0 | 0 |
| WTG-0037 | 2500 | 2830.81 | 113.23% | 50545.72 | 5.83 | 32.83 | 21.67 |
| WTG-0038 | 2500 | -3.05 | 0% | -237.84 | 0 | 0 | 0 |
| WTG-0039 | 2500 | 1806.39 | 72.26% | 37425.98 | 0 | 32.17 | 21 |
| WTG-0040 | 2500 | 2830.2 | 113.21% | 46461.35 | 3.67 | 32.17 | 21 |
| WTG-0041 | 2500 | 1910.86 | 76.43% | 1257.48 | 0 | 1.17 | 0 |
| WTG-0042 | 2500 | 2237.23 | 89.49% | 44187.20 | 0 | 32.5 | 20.83 |
| WTG-0043 | 2500 | 2237.54 | 89.5% | 45317.11 | 0 | 33.17 | 21.5 |
| WTG-0044 | 2500 | 2831.52 | 113.26% | 56745.03 | 5.67 | 32 | 20.83 |
| WTG-0045 | 2500 | 2830.87 | 113.23% | 59077.73 | 7.5 | 31.67 | 21.67 |
| WTG-0046 | 2500 | 2725.37 | 109.01% | 51435.23 | 6 | 32.83 | 21.17 |
| WTG-0047 | 2500 | 2237.89 | 89.52% | 35375.04 | 0 | 31.17 | 20.33 |
| WTG-0048 | 2500 | 2003.03 | 80.12% | 21369.28 | 0 | 21.83 | 10.33 |
| WTG-0049 | 2500 | 2830.67 | 113.23% | 41555.54 | 3.67 | 31.67 | 20 |
| WTG-0050 | 2500 | 1699.85 | 67.99% | 33448.44 | 0 | 29.33 | 19.33 |
| WTG-0051 | 2500 | 2830.93 | 113.24% | 50630.74 | 5.17 | 31.5 | 20.17 |
| WTG-0052 | 2500 | 2725.46 | 109.02% | 52526.99 | 3.17 | 33 | 21.33 |
| WTG-0053 | 2500 | 2725.69 | 109.03% | 52635.04 | 4.33 | 32.67 | 21.33 |
| WTG-0054 | 2500 | 2830.41 | 113.22% | 55411.55 | 5.5 | 31.67 | 20.5 |
| WTG-0055 | 2500 | 2504.88 | 100.2% | 34965.90 | 0.17 | 20.17 | 13.17 |
| WTG-0056 | 2500 | 716.2 | 28.65% | 391.20 | 0 | 1 | 0 |
| WTG-0057 | 2500 | 200.6 | 8.02% | 6452.88 | 0 | 0 | 0 |
| WTG-0058 | 2500 | 1903.5 | 76.14% | 43592.31 | 0 | 31.67 | 21.5 |
| WTG-0059 | 2500 | 2830.99 | 113.24% | 47982.13 | 3.83 | 31.33 | 20.5 |
| WTG-0060 | 2500 | 2530.5 | 101.22% | 31459.50 | 3.5 | 28.17 | 20.33 |
| WTG-0061 | 2500 | 2831.26 | 113.25% | 62047.80 | 12 | 29.33 | 21.83 |
| WTG-0062 | 2500 | 2831.54 | 113.26% | 57741.94 | 6.17 | 33 | 21.67 |
| WTG-0063 | 2500 | 2830.4 | 113.22% | 35359.89 | 5.67 | 23.67 | 16 |
| WTG-0064 | 2500 | 2830.42 | 113.22% | 59508.01 | 7.33 | 31 | 20.67 |
| WTG-0065 | 2500 | 2830.5 | 113.22% | 32992.73 | 3.33 | 31 | 20.5 |
| WTG-0066 | 2500 | 2830.76 | 113.23% | 49003.79 | 6 | 28.83 | 21.5 |
| WTG-0067 | 2500 | 886.89 | 35.48% | 3812.40 | 0 | 8.67 | 0 |
| WTG-0068 | 2500 | 2830.86 | 113.23% | 62817.12 | 7.5 | 33.5 | 22.17 |
| WTG-0069 | 2500 | 2205.88 | 88.24% | 13901.77 | 0 | 10.67 | 4.83 |
| WTG-0070 | 2500 | 2182.93 | 87.32% | 7340.42 | 0 | 7.5 | 1.17 |
| WTG-0071 | 2500 | 2531.53 | 101.26% | 25515.14 | 1.5 | 26.5 | 19 |
| WTG-0072 | 2500 | 2830.08 | 113.2% | 33513.09 | 2.83 | 28.33 | 21 |
| WTG-0073 | 2500 | 2830.93 | 113.24% | 46860.02 | 5.83 | 30.17 | 19.5 |
Find all WTGS that will not have enough or correct data to process Power Values.
[1] "WTG - WTG-0001 - WTG did NOT reach rated power."
[1] "WTG - WTG-0019 - WTG did NOT reach rated power."
[1] "WTG - WTG-0002 - WTG did NOT reach rated power."
[1] "WTG - WTG-0006 - WTG did NOT reach rated power."
[1] "WTG - WTG-0007 - WTG does NOT have enough data to evaluate properly and accurately."
[1] "WTG - WTG-0008 - WTG did NOT reach rated power."
[1] "WTG - WTG-0011 - WTG did NOT reach rated power."
[1] "WTG - WTG-0016 - WTG does NOT have enough data to evaluate properly and accurately."
[1] "WTG - WTG-0018 - WTG did NOT reach rated power."
[1] "WTG - WTG-0026 - WTG did NOT reach rated power."
[1] "WTG - WTG-0029 - WTG does NOT have enough data to evaluate properly and accurately."
[1] "WTG - WTG-0030 - WTG did NOT reach rated power."
[1] "WTG - WTG-0035 - WTG did NOT reach rated power."
[1] "WTG - WTG-0036 - WTG does NOT have enough data to evaluate properly and accurately."
[1] "WTG - WTG-0038 - WTG does NOT have enough data to evaluate properly and accurately."
[1] "WTG - WTG-0039 - WTG did NOT reach rated power."
[1] "WTG - WTG-0041 - WTG did NOT reach rated power."
[1] "WTG - WTG-0042 - WTG did NOT reach rated power."
[1] "WTG - WTG-0043 - WTG did NOT reach rated power."
[1] "WTG - WTG-0047 - WTG did NOT reach rated power."
[1] "WTG - WTG-0048 - WTG did NOT reach rated power."
[1] "WTG - WTG-0050 - WTG did NOT reach rated power."
[1] "WTG - WTG-0056 - WTG did NOT reach rated power."
[1] "WTG - WTG-0057 - WTG did NOT reach rated power."
[1] "WTG - WTG-0058 - WTG did NOT reach rated power."
[1] "WTG - WTG-0067 - WTG did NOT reach rated power."
[1] "WTG - WTG-0069 - WTG did NOT reach rated power."
[1] "WTG - WTG-0070 - WTG did NOT reach rated power."